﻿CREATE TABLE [flcrTM].[DEVICE_CATEGORY_TYPE_XREF] (
    [TM_DEVICE_CAT_TYPE_XREF_ID] INT          IDENTITY (1, 1) NOT NULL,
    [TIME_KEY]                   INT          NOT NULL,
    [DEVICE_CAT_TYPE_XREF_ID]    INT          NOT NULL,
    [AUDIT_USER]                 VARCHAR (50) NOT NULL,
    [AUDIT_DTTM]                 DATETIME     NOT NULL,
    [AUDIT_DTTM_TZ]              INT          NOT NULL,
    [AUDIT_MOD_USER]             VARCHAR (50) NOT NULL,
    [AUDIT_MOD_DTTM]             DATETIME     NOT NULL,
    [AUDIT_MOD_DTTM_TZ]          INT          NOT NULL,
    [ACTIVE_FLG]                 BIT          NOT NULL,
    [DEVICE_CAT_ID]              INT          NOT NULL,
    [DEVICE_TYPE]                INT          NOT NULL
);

